package com.mbds.accelerometer.db;

import android.provider.BaseColumns;

/**
 * Describe the DB schema
 *
 */
public class SensorContract {
	
	public SensorContract() {}
	
	public static abstract class SensorEntry implements BaseColumns {
		public static final String TABLE_NAME = "sensoractivity";
		public static final String COLUMN_NAME_ID = "id";
		public static final String COLUMN_NAME_X = "x";
		public static final String COLUMN_NAME_Y = "y";
		public static final String COLUMN_NAME_Z = "z";
		
		public static final String SQL_CREATE_ENTRIES = "CREATE TABLE " + SensorEntry.TABLE_NAME + " ( "
				+ SensorEntry.COLUMN_NAME_ID + " INTEGER PRIMARY KEY,"
						+ SensorEntry.COLUMN_NAME_X + " FLOAT,"
						+ SensorEntry.COLUMN_NAME_Y + " FLOAT,"
						+ SensorEntry.COLUMN_NAME_Z + " FLOAT" 
				+ " )";
		public static final String SQL_DELETE_ENTRIES = "DROP TABLE IF EXISTS " + SensorEntry.TABLE_NAME;
		public static final String SQL_TRUNCATE_TABLE = "TRUNCATE TABLE[" + SensorEntry.TABLE_NAME + "]";
		
	}

}
